using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VMAPDEF
    {
        //hexadecimal 
        public DataSet QMAPDEF00(DataRow dwData)
        {

            or1 = OracleDB.CreateCommand();

            or1.CommandText = "SELECT Distinct MDNAME AS KEY,MDNAME,MDNAME AS DES FROM MAPDEF"
                + " WHERE MDMANDANT=:MDMANDANT: ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QMAPDEF01(DataRow dwData)
        {

            or1 = OracleDB.CreateCommand();

            or1.CommandText = "SELECT  utl_raw.cast_to_varchar2(MDALLTAB1)  AS ALLTAB1, utl_raw.cast_to_varchar2(MDALLTAB2) AS ALLTAB2, utl_raw.cast_to_varchar2(MDALLTAB3) AS ALLTAB3, utl_raw.cast_to_varchar2(MDALLTAB4) AS ALLTAB4,"
                + "utl_raw.cast_to_varchar2(MDALLTAB5) AS ALLTAB5, utl_raw.cast_to_varchar2(MDALLTAB6) AS ALLTAB6, utl_raw.cast_to_varchar2(MDALLTAB7) AS ALLTAB7, utl_raw.cast_to_varchar2(MDZUSTAB1) AS ZUSTAB1,utl_raw.cast_to_varchar2(MDZUSTAB2) AS ZUSTAB2,"
                + " P.* FROM MAPDEF P "
            + " WHERE MDMANDANT=:MDMANDANT: AND MDNAME=:MDNAME: ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1); 
            SResult.Tables[0].TableName = TableName; 
            return SResult;
        } 
    }
}
